How to: Filter records by typing values in a blank view using Filter By Form.
Solution:
In the Table Datasheet view or Form view, use the 'Filter By Form' command on the 'Filter' submenu under the 'Records' menu.
1) If the Database window is not active, activate the Database window.
2) Go to the Table Datasheet view or the Form view.
3) Select the 'Records' menu and select 'Filter'. (A submenu appears.)
4) Select 'Filter By Form' from the 'Filter' submenu. (The <table or form name>: Filter by Form window appears, where <table or form name> is the name of the open table or form, and a new menu appears at the top of the screen.)
5) Click the 'Look For' tab at the bottom of the window.
6) Click in the field in which to specify criteria for the records. (A down arrow appears.)
NOTE: Records must meet the specified criteria in order to be returned by the filter.
7) Click on the arrow. (A drop-down list appears.)
8) Select the desired value for the criteria from the drop-down list.
9) Repeat steps 6) through 8), clicking in the appropriate column, for each field for which to specify criteria.
NOTE: If values are specified in more than one field, the filter returns records ONLY if they meet the criteria in all the fields specified. In other words, the filter acts as an AND statement.
10) (Optional) To specify alternative values to include records in the filter:
a) Click the 'Or' tab at the bottom of the window. (A new sheet appears.)
b) Click in the field in which to specify criteria on the 'Or' tab. (A down arrow appears.)
c) Click on the arrow. (A drop-down list appears.)
d) Select the desired value for the criteria from the drop-down list.
NOTE: The filter returns records that have ALL the values specified on the 'Look For' tab OR all the values specified on the second tab OR the third tab OR the fourth tab, etc. In other words, the 'or' criteria causes the filter to act as an OR statement).
e) Repeat steps 10)b) through 10)d) for each, clicking in the appropriate column, for each field for which to specify criteria on the 'Or' tab.
f) Repeat steps 10)a) through 10)e) for each set of alternative values to specify.
NOTE: The filter returns records that have ALL the values specified on the 'Look For' tab OR all the values specified on the second tab OR the third tab OR the fourth tab, etc. (i.e., the filter acts as an OR statement).
11) Select the 'Filter' menu and select 'Apply Filter/Sort'.
12) To view all entries in the table again, select the 'Records' menu and select 'Remove Filter/Sort'.
13) To reapply the previous existing filter, select the 'Records' menu and select 'Apply Filter/Sort'.
